Risk Assessment for Relational Database Schema - based Constraint Using State Machine Diagram
نویسنده
چکیده
Abstract— Information is a critical asset of an organization. This is why reducing the chance of data loss must be a primary concern. This research focuses on the risk assessment issue in physical level of data implementation, which includes identifying risk factors and assigning a hazard level. This research will investigate how to predict the chance of incorrect data based on breaking risk assessment constraints using a state machine diagram. The diagram represents the status of the data when that data must change as a result of a program execution. The advantages of this research include helping software development teams identify what risks may occur in different scenarios, and helping reduce development cost by allowing them to minimize those risks.
منابع مشابه
Extending an ORDBMS: The StateMachine Module
Extensibility is one of the mayor benefits of object -relational database management systems. We have used this system property to implement a StateMachine Module inside an object-relational database management system. The module allows the checking of dynamic integrity constraints as well as the execution of active behavior specified with the UML. Our approach demonstrates that extensibility c...
متن کاملFormalizing Object-Relational Structural Metrics
This paper describes a meta-modeling approach to formalize a set of metrics suited for object-relational databases. Those metrics are expected to help database designers in their activity, offering a mechanism for comparing and selecting, among possible schema designs, the one with more quality. Formalization of metrics is important for avoiding misinterpretation of definitions, while producing...
متن کاملFinding where to apply object-relational database schema refactorings: an ontology-guided approach
Less complex object-relational (OR) database schemas are more understandable, changeable, maintainable and reusable. This paper addresses the use of OR metrics to (i) detect complex fragments of OR database schemas, which are candidates to perform refactorings, and (ii) to assess if the application of the selected refactorings has indeed reduced the schema complexity. The schema metrics are for...
متن کاملERM-Tutor an ER-to-Relational Mapping Tutor
Relational Databases are extremely commonplace in today’s society. Because of this the skill of designing such databases is often taught in university courses, where part of this skill involves being able to map from a conceptual schema to relational database tables. This is a mapping algorithm that maps from the Entity Relationship conceptual schema to relational database tables, and applying ...
متن کاملDOMINO: Fast and Effective Test Data Generation for Relational Database Schemas
An organization’s databases are often one of its most valuable assets. Data engineers commonly use a relational database because its schema ensures the validity and consistency of the stored data through the specification and enforcement of integrity constraints. To ensure their correct specification, industry advice recommends the testing of the integrity constraints in a relational schema. Si...
متن کامل